Gen Report Date: 2024-07-17

Years: 2021, 2022, 2023

Channels: MNG, WTC

Measures: Product Revenue($), Product Qty(#)

1 ) Product Revenue KPI

2 ) Channel

2.1 Product Revenue Trend

2.2 Product Revenue Portfolio

2.3 Product Revenue Portfolio Distribution

3 ) Brand

3.1 Product Revenue Trend

3.1.1 Total: MNG + WTC

3.1.2 MNG

3.1.3 WTC

3.2 Product Revenue Portfolio

3.2.1 Total: MNG + WTC

3.2.2 MNG

3.2.3 WTC

3.3 Product Revenue Portfolio Distribution

3.3.1 Total: MNG + WTC

3.3.2 MNG

3.3.3 WTC

3.4 Product Revenue and Qty

4 ) Product

4.1 Product Revenue Portfolio Distribution

4.2 Top 80% Revenue

4.2.1 Total: MNG + WTC

4.2.2 MNG

4.2.3 WTC

4.3 Product Revenue and Qty

4.4 Product Revenue Trend

4.4.1 Total: MNG + WTC

4.4.2 MNG

4.4.3 WTC

4.5 Correlation Product Revenue

5 ) Appendix

Data Summary Description

Data : Scan Sales Report (MNG and WTC)

Dimensions: 3429 x 19
Duplicates: 0
No Variable Stats / Values Freqs (% of Valid) Graph Missing
1 CHANNEL [character]
1. MNG
2. WTC
1321(38.5%)
2108(61.5%)
0 (0.0%)
2 ITEMID [character]
1. DCATA040BTHK02
2. DLBSC120BXHK01
3. DLJSC120BXHK01
4. FDC02014
5. FDC07016
6. FDC45016
7. FGB016
8. FHP013
9. FHP013TWFJT01C
10. FIS014
[ 73 others ]
62(1.8%)
62(1.8%)
62(1.8%)
62(1.8%)
62(1.8%)
62(1.8%)
62(1.8%)
62(1.8%)
62(1.8%)
62(1.8%)
2809(81.9%)
0 (0.0%)
3 DATE [Date]
min : 2021-01-01
med : 2022-04-01
max : 2023-07-01
range : 2y 6m 0d
31 distinct values 0 (0.0%)
4 PROD_REV [numeric]
Mean (sd) : 199145.7 (485628.2)
min ≤ med ≤ max:
-199 ≤ 5581.2 ≤ 5500000
IQR (CV) : 172673.7 (2.4)
1489 distinct values 0 (0.0%)
5 PROD_QTY [numeric]
Mean (sd) : 845.7 (5225.7)
min ≤ med ≤ max:
-1 ≤ 0 ≤ 130148
IQR (CV) : 451 (6.2)
1081 distinct values 0 (0.0%)
6 DATAAREAID [character] 1. vghp
3410(100.0%)
19 (0.6%)
7 ITEMNAME_ENG [character]
1. Extra Strength Uricsil 60
2. Extra Strength Vita Joint
3. Extra Strength Vita Yin Y
4. Extra Strength Vita Yin Y
5. Fortified I See 40's
6. G.E. Yunzhi Essence 60's
7. Glucobest 60's
8. Herba Precious 30's
9. Herba Precious 30's Twin
10. Lingzhi 72's (NB) Twin Pa
[ 72 others ]
62(1.8%)
62(1.8%)
62(1.8%)
62(1.8%)
62(1.8%)
62(1.8%)
62(1.8%)
62(1.8%)
62(1.8%)
62(1.8%)
2790(81.8%)
19 (0.6%)
8 ITEMNAME_CHI [character]
1. Extra Strength Uricsil 60
2. Lingzhi 72's (New Box) Tw
3. Lingzhi K-Cap 72's (NB) T
4. Vita Hair 90's Twin Pack
5. 活關素特強特效60粒
6. 維特健靈 加強配方 知音蟲草 60粒 (Alu)
7. 維特健靈 加強配方 知音蟲草孖裝+加強配方 知音蟲
8. 維特健靈 寧心 60粒
9. 維特健靈 小兒靈芝蜜 250毫升
10. 維特健靈 強效目清素 40粒
[ 72 others ]
62(1.8%)
62(1.8%)
62(1.8%)
62(1.8%)
62(1.8%)
62(1.8%)
62(1.8%)
62(1.8%)
62(1.8%)
62(1.8%)
2790(81.8%)
19 (0.6%)
9 PRODUCTTYPE [character] 1. 1
3410(100.0%)
19 (0.6%)
10 ITEMGROUPID [character]
1. DC
2. LZ
3. VH
4. YY
5. DCJ
6. HP
7. IS
8. JT
9. YZ
10. GB
[ 20 others ]
1023(30.0%)
341(10.0%)
279(8.2%)
186(5.5%)
155(4.5%)
124(3.6%)
124(3.6%)
124(3.6%)
124(3.6%)
62(1.8%)
868(25.5%)
19 (0.6%)
11 Company [character] 1. VGHP
3410(100.0%)
19 (0.6%)
12 Brand [factor]
1. VG
2. VH
3. DC
4. NV
5. WATON
1612(47.3%)
341(10.0%)
1271(37.3%)
124(3.6%)
62(1.8%)
19 (0.6%)
13 SubBrand [character]
1. Functions
2. JointsAndBones
3. LZ
4. Vitamins
5. VH
6. YY
7. HP
8. IS
9. YZ
10. VC
[ 16 others ]
496(15.1%)
434(13.2%)
403(12.3%)
341(10.4%)
217(6.6%)
186(5.7%)
124(3.8%)
124(3.8%)
124(3.8%)
93(2.8%)
744(22.6%)
143 (4.2%)
14 ProductCategoryName [character]
1. Capsule
2. Chewable
3. Foot Patch
4. Honey
5. Sachet
6. Shampoo
7. Softgel
8. Spray
9. Tablet
10. Tonic
1674(55.7%)
31(1.0%)
62(2.1%)
62(2.1%)
155(5.2%)
31(1.0%)
341(11.3%)
31(1.0%)
589(19.6%)
31(1.0%)
422 (12.3%)
15 ProductSubCategoryName [character] 1. Finished Goods
2976(100.0%)
453 (13.2%)
16 ProductSubCategoryID [character]
1. VG_DC_JNB_SOF_FG
2. VG_DC_VTM_TAB_FG
3. VG_VG_LZ_CAP_FG
4. VG_DC_FTN_TAB_FG
5. VG_VG_YY_CAP_FG
6. VG_DC_FTN_CAP_FG
7. VG_VH_VH_CAP_FG
8. VG_DC_JNB_TAB_FG
9. VG_VG_HP_CAP_FG
10. VG_VG_IS_CAP_FG
[ 31 others ]
248(7.3%)
248(7.3%)
217(6.4%)
186(5.5%)
186(5.5%)
155(4.5%)
155(4.5%)
124(3.6%)
124(3.6%)
124(3.6%)
1643(48.2%)
19 (0.6%)
17 YEAR [integer]
Mean (sd) : 2021.8 (0.8)
min ≤ med ≤ max:
2021 ≤ 2022 ≤ 2023
IQR (CV) : 1 (0)
2021:1320(38.5%)
2022:1332(38.8%)
2023:777(22.7%)
0 (0.0%)
18 MONTH [integer]
Mean (sd) : 5.9 (3.3)
min ≤ med ≤ max:
1 ≤ 6 ≤ 12
IQR (CV) : 6 (0.6)
12 distinct values 0 (0.0%)
19 MONTH_ABBR [character]
1. Apr
2. Feb
3. Jan
4. Jul
5. Jun
6. Mar
7. May
8. Aug
9. Dec
10. Nov
[ 2 others ]
332(9.7%)
332(9.7%)
332(9.7%)
332(9.7%)
332(9.7%)
332(9.7%)
332(9.7%)
221(6.4%)
221(6.4%)
221(6.4%)
442(12.9%)
0 (0.0%)